-
Re: Formula to Track Consultant Hours per Month
You are going to want to use something along the lines of... =SUMIFS({Range to Sum}, {Name Column}, "Bill M", {Month Column}, M@row)6 · -
Re: Filtering on dashboards?
Ok. On the filter request sheet, you would set it up to have those three columns plus a system generated Created (date) column. Set the form up to include the three searchable columns and have the fo…6 · -
Formula in a cell that is within a range referenced by the formula
@Genevieve P & @Andrée Starå I was finally able to do some testing based on THIS THREAD and the recent discovery that you can reference a range in a formula that covers the cell that the form…5 ·